CREATE TABLE [dbo].[RoleMain]
(
[RoleKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_RoleMain_RoleKey] DEFAULT (newid()),
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RoleMain_Name] DEFAULT (''),
[Description] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RoleMain_Description] DEFAULT (''),
[IsSystem] [bit] NOT NULL CONSTRAINT [DF_RoleMain_IsSystem] DEFAULT ((0)),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_RoleMain_UpdatedOn] DEFAULT (getdate()),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RoleMain] ADD CONSTRAINT [PK_RoleMain] PRIMARY KEY CLUSTERED ([RoleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RoleMain_UpdatedByUserKey] ON [dbo].[RoleMain] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleMain] ADD CONSTRAINT [FK_RoleMain_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO